package com.longrise.android.upload_offline.synchron;

/**
 * Created by sujizhong on 16/3/17.
 */
public class VideoDB {

    //断点播放
    public static final String TABLE_NAME_CUTLINE = "cutline_play";
    public static final String SCORE_ID = "score_id";
    public static final String SCORE_POSITIION = "score_position";
    public static final String SCORE_STATE = "score_state";
    public static final String SCORE_START_TIME = "score_start_time";

    public static final String CREATE_TABLE_CUTLINE_PLAY_ = "create table " + TABLE_NAME_CUTLINE + "(" +
            "_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
            SCORE_ID + " string," +
            SCORE_POSITIION + " int," +
            SCORE_START_TIME + " int," +
            SCORE_STATE + " int" +
            ")";


    //同步学习记录
    public static final String TABLE_NAME = "offline";          //数据表名
    public static final String EXOIRETIME = "expiretime";       //过期时间
    public static final String STUDYRECORDS = "studyrecords";   //学习记录
    public static final String ID = "id";                       //学习记录ID
    public static final String STUDENTNO = "sutdentno";         //当前学号
    public static final String EFFECTTIME = "effecttime";       //有效学时
    public static final String COURSEID = "courseid";

    public static final String CREATE_TABLE_OFFLINE = "create table if not exists " + TABLE_NAME + "(" +
            "_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
            EXOIRETIME + " string," +
            STUDYRECORDS + " string," +
            ID + " string," +
            STUDENTNO + " string," +
            EFFECTTIME + " string" +
            ")";

}
